const { DataTypes } = require('sequelize');
const sequelize = require('../init/sequelize');

const Business = sequelize.define('Business', {
    id: {
        type: DataTypes.INTEGER,
        primaryKey: true,
        autoIncrement: true
    },
    year: {
        type: DataTypes.INTEGER,
        allowNull: true
    },
    month: {
        type: DataTypes.INTEGER,
        allowNull: true
    },
    day: {
        type: DataTypes.INTEGER,
        allowNull: true
    },
    turnover: {
        type: DataTypes.INTEGER,
        allowNull: true
    },
    averPrice: {
        type: DataTypes.INTEGER,
        allowNull: true
    }
}, {
    tableName: 'business',
    timestamps: false // 如果你的表中没有时间戳字段，需要将timestamps设置为false
});

module.exports = Business;